{
  "PageType": 0,
  "ColumnCount": 18,
  "RowCount": 57,
  "Formulas": {
    "49,4": "ODATA(\"bas_warehouseinfo_keyroad/$count?$filter=whsloccode eq \"&IF(ISBLANK(F20),\"null\",\"'\"&F20&\"'\"))",
    "23,5": "IFERROR(ctns*M16,0)",
    "9,5": "ODATA(\"som_distd_keyroad?$select=itemcode&$filter=billno eq \"&IF(ISBLANK(F4),\"null\",\"'\"&F4&\"'\")&\" and oribillno eq \"&IF(ISBLANK(F6),\"null\",\"'\"&F6&\"'\")&\" and barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))",
    "7,5": "ODATA(\"som_distd_keyroad?$select=locname&$filter=billno eq \"&IF(ISBLANK(F4),\"null\",\"'\"&F4&\"'\")&\" and oribillno eq \"&IF(ISBLANK(F6),\"null\",\"'\"&F6&\"'\")&\" and barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))",
    "44,13": "B26",
    "43,4": "ODATA(\"srm_quickscanitem/$count?$filter=billno eq \"&IF(ISBLANK(F4),\"null\",\"'\"&F4&\"'\")&\" and oribillno eq \"&IF(ISBLANK(F6),\"null\",\"'\"&F6&\"'\"))",
    "15,12": "ODATA(\"bas_iteminfo_keyroad?$select=packsize&$filter=itemcode eq \"&IF(ISBLANK(F10),\"null\",\"'\"&F10&\"'\")&\" and barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))",
    "11,12": "E45",
    "11,4": "ODATA(\"som_distd_keyroad?$select=qty&$filter=billno eq \"&IF(ISBLANK(F4),\"null\",\"'\"&F4&\"'\")&\" and oribillno eq \"&IF(ISBLANK(F6),\"null\",\"'\"&F6&\"'\")&\" and barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))-M12",
    "44,4": "SUM(I47)",
    "48,4": "E12",
    "15,5": "ODATA(\"v_wrm_stock_keyroad?$select=stockqty&$filter=barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))",
    "13,5": "ROUND(ODATA(\"v_wrm_stock_keyroad?$select=stockqty&$filter=barcode eq \"&IF(ISBLANK(barcode),\"null\",\"'\"&barcode&\"'\"))/M16,0)",
    "13,12": "ROUND(M12/M16,0)"
  },
  "CustomNames": [
    {
      "Name": "qtyout",
      "Formula": "dlg_quick_scanitem_dist_sygc!$F$24"
    },
    {
      "Name": "barcode",
      "Formula": "dlg_quick_scanitem_dist_sygc!$F$18"
    },
    {
      "Name": "ctns",
      "Formula": "dlg_quick_scanitem_dist_sygc!$F$22"
    }
  ]
}